Welcome to this video
on Assignment Overview: Data Setup Using
Relational Database. After watching this video, you will be able to identify the main objective
of the assignment. Discuss the exercises
involved in setting up a transactional
database using MySQL. In this assignment, you will
gain hands on experience in setting up a transactional
database using MySQL. It provides a set of exercises
to help you design and populate a transactional
database in MySQL, focusing on developing
core skills for online transaction
processing or OLTP systems. You will work within
the FinPro database to establish a structured
schema, load data, and perform queries, simulating real world database tasks essential for financial
institutions. To begin the assignment, ensure your MySQL server is running, as this lab environment setup is necessary for all
subsequent exercises. In the first exercise, you will design the schema for the OLTP database within
the FinPro database. You will create tables
for customer information, transactions, account
types, branches, countries, and US cities. Establishing these tables and defining their
relationships prepares the database to handle transactional data
accurately and efficiently. In the second exercise, you will load the data into the OLTP database by executing the provided
data creation scripts. These scripts will populate the database with
essential information, transforming the schema into a fully functioning
system ready for query. After loading the data, you'll verify your setup by listing all tables
within the database and writing SQL queries to determine the record
count in each table. This check ensures
that data is correctly inserted and that each table
is loaded as expected. These exercises build
practical skills necessary for managing
financial data, helping you understand how
to effectively design, populate, and query a
transactional database. Throughout the
assignment, document your progress by taking screenshots of each command you execute and the
corresponding output. Naming these screenshots, according to the task
or command performed, will make it easier
to track your work, providing a clear record for future reference
and verification. In this video, you learned
that this assignment involves designing and populating a transactional
database in MySQL, focusing on schema
creation, data insertion, and validation queries
for the FinPro database, which simulates OLTP tasks relevant to financial
institutions. You will complete three
exercises, schema design, table population using
data scripts and verification through SQL
queries to check table data, ensuring accurate setup
and functionality. Document your progress by taking screenshots of each
command and output, creating a record for
future reference.